package top.zhangjianyong.tools.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import top.zhangjianyong.tools.entity.WxBill;

import java.util.List;

public interface WxBillMapper extends BaseMapper<WxBill> {
    @Select("SELECT * from wx_bill a where not EXISTS (SELECT 1 from wx_bill b where b.order_no =a.order_no and b.create_time > a.create_time)")
    List<WxBill> listTheLast();
}
